"; } // select database $db_select = mysqli_select_db($db_server, $db_database); if (!$db_select) { die("Unable to select database " . $db_database); } else { echo "Selected database " . $db_database . "
"; } // sql select command //$query = "SELECT * FROM Tokens WHERE Token='Hwang'"; // create the sql command //$data = "Hwang"; $query = "SELECT * FROM Tokens WHERE deviceID='$deviceID'"; // create the sql command // $query = "SELECT * FROM Tokens"; // create the sql command $result = mysqli_query($db_server, $query); // execute the sql command if (!$result) die ("Error executing SELECT"); $rows = mysqli_num_rows($result); // get number of rows retrieved from the command echo "Retrieved " . $rows . " row(s)
"; if ($rows == 1) { $record = mysqli_fetch_row($result); // get record echo 'Retrieved DeviceID: ' . $record[0] . '
'; echo 'Token: ' . $record[1] . '
'; } else { // new device ID so save the token $query = "INSERT INTO Tokens (DeviceID, Token) VALUES ('$deviceID', '$token')"; $result = mysqli_query($db_server, $query); // execute the sql command if (!$result) die ("Error executing INSERT"); echo 'Inserted new DeviceID: ' . $deviceID . '
'; echo 'Token: ' . $token . '
'; } echo "saved deviceID=" . $deviceID . " token=" . $token; ?>